﻿<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8" />
    <title>选择组</title>
    <link href="../../Comm/Style/CommStyle.css" rel="stylesheet" type="text/css" />
    <link href="../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
    <link href="../../Scripts/easyUI/themes/default/easyui.css" rel="stylesheet" type="text/css" />
    <link href="../../Scripts/easyUI/themes/icon.css" rel="stylesheet" type="text/css" />
    <script src="../../Scripts/jquery-1.7.2.min.js" type="text/javascript"></script>
    <script src="../../Scripts/easyUI/jquery.easyui.min.js" type="text/javascript"></script>
    <script src="../../Scripts/QueryString.js" type="text/javascript"></script>
    <script type="text/javascript" src="../../Scripts/config.js"></script>
    <script type="text/javascript" src="../../Comm/Gener.js"></script>
    <script src="../../Scripts/EasyUIUtility.js" type="text/javascript"></script>
    <link href="../../Style/skin/adminfont/iconfont.css" rel="stylesheet" />
    <link href="../../Style/skin/css/Default.css" rel="stylesheet" />
    <link href="../../Scripts/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
    <base target="_self" />
    <script type="text/javascript">

        //页面启动函数.
        var Data;
        $(function () {

            var orgNo = GetQueryString("OrgNo");
            if (orgNo == null || orgNo == undefined)
                orgNo = 0;

        });

        function Save() {

            var en = new Entity("BP.CCFast.CCMenu.PowerCenter");
            en.CopyURL();
            en.CtrlModel = "SQL";

            en.IDs = $("#TB_SQL").val();
            en.IDNames = $("#TB_SQL").val();
            en.Insert();

            var url = "../PowerCenter.htm";
            url += "?CtrlObj=" + GetQueryString("CtrlObj") + "&CtrlPKVal=" + GetQueryString("CtrlPKVal") + "&CtrlGroup=" + GetQueryString("CtrlGroup");
            SetHref(url);
            window.parent.selectStasWindowClose("确定");
        }
    </script>
</head>
<body>

    请输入SQL表达式:
    <textarea id="TB_SQL" name="TB_SQL" style="width:90%;">
</textarea>
    <input type="button" value="保存" onclick="Save();">
    <fieldset>
        <legend>说明</legend>
        <ul>
            <li>1. 输入的SQL是一个查询语句，返回的一行的第一列数据。</li>
            <li>2. 该数据大于0 ，就是真(可以拥有此权限)，否则就是假（不能操作此权限）。</li>
            <li>3. SQL语句支持ccbpm的表达式，比如：SELECT count(*) FROM Port_Dept WHERE No='@WebUser.FK_Dept'。</li>
            <li>  @WebUser.No 当前登录的人员编号 </li>
            <li>  @WebUser.FK_Dept 当前登录的部门编号 </li>
            <li>  @RDT 是当前日期， 比如：2020-01-01  </li>
            <li>  @DateTime 是当前时间， 比如：2020-01-01 10:09  </li>
        </ul>
    </fieldset>
</body>
</html>
